package com.example.board.pojo.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import com.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
import lombok.*;

@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@Builder
@HeadStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER,verticalAlignment = VerticalAlignmentEnum.CENTER)//标题样式,垂直水平居中
@HeadFontStyle(fontName = "微软雅黑",fontHeightInPoints = 11,bold = BooleanEnum.FALSE)//表头字体样式
@HeadRowHeight(value = 50)//表头行高
@ContentFontStyle(fontName = "微软雅黑",fontHeightInPoints = 11)//内容字体样式
@ContentRowHeight(value = 30)//内容行高
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER,verticalAlignment = VerticalAlignmentEnum.CENTER)//内容样式,垂直水平居中
public class ExcelSalesmanVo {

    @ExcelProperty(value = "业务员名称",index = 0)
    @ColumnWidth(value = 16)
    private String  username;

    @ExcelProperty(value = "入职时间",index = 1)
    @ColumnWidth(value = 23)
    private String entryTime;

    @ExcelProperty(value = "区域",index = 2)
    @ColumnWidth(value = 23)
    private String province;

    @ExcelProperty(value = "总拜访数",index = 3)
    private String visitTotal;

    @ExcelProperty(value = "总下单数",index = 4)
    private String orderTotal;

    @ExcelProperty(value = "团队",index = 5)
    @ColumnWidth(value = 23)
    private String teamName;

    @ExcelProperty(value = "本周期（月）",index = 6)
    private String mothNow;

    @ExcelProperty(value = "对比周期（月）",index = 7)
    private String mothData;

    @ExcelProperty(value = "对比周期（月）总拜访",index = 8)
    private String mothDataVisit;

    @ExcelProperty(value = "对比周期（月）总单数",index = 9)
    private String mothDataOrder;

    @ExcelProperty(value = "本周期总金额(元）",index = 10)
    private String mothNowOrderTotal;

    @ExcelProperty(value = "对比周期总金额(元）",index = 11)
    private String mothDataOrderTotal;

    @ExcelProperty(value = "增长比% ",index = 12)
    private String increaseRate;


}
